package com.itheima.mapper.store;

import org.apache.ibatis.annotations.*;

@Mapper
public interface BrokenMapper {

    @Select("select count(id) from member")
    @Results(id = "memMap",value = {
            @Result(id = true,column = "id",property = "id"),
            @Result(column = "name",property = "name"),
            @Result(column = "nickname",property = "nickname"),
            @Result(column = "phoneNum",property = "phoneNum"),
            @Result(column = "email",property = "email")
    })
    int findNum();

    /*@Insert("insert into member_num values(#{id},#{num},#{date})")
    void saveNum(MemberNum memberNum);*/


    @Select("select count(id) from member where regTime <= #{m}")
//    @ResultMap("memMap")
    Integer findMemberCountBeforeDate(String m);
}
